object smNF: TsmNF
  OldCreateOrder = False
  Height = 508
  Width = 637
  object dtsNF_Nota: TSQLDataSet
    CommandText = 'select * from NF_NOTAS'#13#10'WHERE ID_NOTA_FISCAL = :ID_NOTA_FISCAL'
    DbxCommandType = 'Dbx.SQL'
    MaxBlobSize = -1
    Params = <
      item
        DataType = ftInteger
        Name = 'ID_NOTA_FISCAL'
        ParamType = ptInput
      end>
    SQLConnection = dmMain.NfConn
    Left = 272
    Top = 248
    object dtsNF_NotaID_NOTA_FISCAL: TIntegerField
      AutoGenerateValue = arAutoInc
      FieldName = 'ID_NOTA_FISCAL'
      ProviderFlags = [pfInUpdate, pfInKey]
      Required = True
    end
    object dtsNF_NotaUF_EMITENTE: TStringField
      FieldName = 'UF_EMITENTE'
      ProviderFlags = [pfInUpdate]
      Required = True
      FixedChar = True
      Size = 2
    end
    object dtsNF_NotaDT_EMISSAO: TDateField
      FieldName = 'DT_EMISSAO'
      ProviderFlags = [pfInUpdate]
      Required = True
    end
    object dtsNF_NotaFORMA_PAGTO: TSmallintField
      FieldName = 'FORMA_PAGTO'
      ProviderFlags = [pfInUpdate]
      Required = True
    end
    object dtsNF_NotaDESC_NAT_OP: TStringField
      FieldName = 'DESC_NAT_OP'
      ProviderFlags = [pfInUpdate]
      Required = True
      FixedChar = True
      Size = 60
    end
    object dtsNF_NotaSERIE_DOC: TStringField
      FieldName = 'SERIE_DOC'
      ProviderFlags = [pfInUpdate]
      Required = True
      FixedChar = True
      Size = 3
    end
    object dtsNF_NotaNUMERO_DOC: TStringField
      FieldName = 'NUMERO_DOC'
      ProviderFlags = [pfInUpdate]
      FixedChar = True
      Size = 9
    end
    object dtsNF_NotaFORMA_EMISSAO: TSmallintField
      FieldName = 'FORMA_EMISSAO'
      ProviderFlags = [pfInUpdate]
    end
    object dtsNF_NotaTIPO_IMPRESSAO: TSmallintField
      FieldName = 'TIPO_IMPRESSAO'
      ProviderFlags = [pfInUpdate]
    end
    object dtsNF_NotaCOD_MUNICIPIO: TStringField
      FieldName = 'COD_MUNICIPIO'
      ProviderFlags = [pfInUpdate]
      FixedChar = True
      Size = 7
    end
    object dtsNF_NotaDT_SAIDA_ENTRAD: TDateField
      FieldName = 'DT_SAIDA_ENTRAD'
      ProviderFlags = [pfInUpdate]
    end
    object dtsNF_NotaFINALIDADE_EMISSAO: TSmallintField
      FieldName = 'FINALIDADE_EMISSAO'
      ProviderFlags = [pfInUpdate]
    end
    object dtsNF_NotaMODELO: TStringField
      FieldName = 'MODELO'
      ProviderFlags = [pfInUpdate]
      Required = True
      FixedChar = True
      Size = 2
    end
    object dtsNF_NotaCID_NOTA_FISCAL: TIntegerField
      FieldName = 'CID_NOTA_FISCAL'
      ProviderFlags = [pfInUpdate]
    end
    object dtsNF_NotaTIPO_OPERACAO: TSmallintField
      FieldName = 'TIPO_OPERACAO'
      ProviderFlags = [pfInUpdate]
    end
    object dtsNF_NotaHORA_ENT_SAI: TStringField
      FieldName = 'HORA_ENT_SAI'
      ProviderFlags = [pfInUpdate]
      FixedChar = True
      Size = 8
    end
    object dtsNF_NotaCODIGO_ACESSO: TStringField
      FieldName = 'CODIGO_ACESSO'
      ProviderFlags = [pfInUpdate]
      FixedChar = True
      Size = 8
    end
    object dtsNF_NotaCHAVE_ACESSO: TStringField
      FieldName = 'CHAVE_ACESSO'
      ProviderFlags = [pfInUpdate]
      Size = 47
    end
    object dtsNF_NotaVERSAO_LAYOUT: TFMTBCDField
      FieldName = 'VERSAO_LAYOUT'
      ProviderFlags = [pfInUpdate]
      Precision = 15
      Size = 2
    end
  end
  object dspNF_Nota: TDataSetProvider
    DataSet = dtsNF_Nota
    UpdateMode = upWhereKeyOnly
    Left = 280
    Top = 264
  end
  object dtsNF_Produtos: TSQLDataSet
    SchemaName = 'sysdba'
    CommandText = 
      'select * from NF_PRODUTOS'#13#10'WHERE ID_NOTA_FISCAL = :ID_NOTA_FISCA' +
      'L'
    DbxCommandType = 'Dbx.SQL'
    DataSource = dsNF_Nota
    MaxBlobSize = -1
    Params = <
      item
        DataType = ftInteger
        Name = 'ID_NOTA_FISCAL'
        ParamType = ptInput
      end>
    SQLConnection = dmMain.NfConn
    Left = 368
    Top = 248
    object dtsNF_ProdutosID_ITEM: TIntegerField
      FieldName = 'ID_ITEM'
      ProviderFlags = [pfInUpdate, pfInWhere, pfInKey]
      Required = True
    end
    object dtsNF_ProdutosID_NOTA_FISCAL: TIntegerField
      FieldName = 'ID_NOTA_FISCAL'
      ProviderFlags = [pfInUpdate, pfInWhere, pfInKey]
      Required = True
    end
    object dtsNF_ProdutosNCM: TStringField
      FieldName = 'NCM'
      ProviderFlags = [pfInUpdate]
      FixedChar = True
      Size = 8
    end
    object dtsNF_ProdutosDESCRICAO: TStringField
      FieldName = 'DESCRICAO'
      ProviderFlags = [pfInUpdate]
      Size = 120
    end
    object dtsNF_ProdutosEAN: TStringField
      FieldName = 'EAN'
      ProviderFlags = [pfInUpdate]
      FixedChar = True
      Size = 14
    end
    object dtsNF_ProdutosCODIGO: TStringField
      FieldName = 'CODIGO'
      ProviderFlags = [pfInUpdate]
      FixedChar = True
      Size = 60
    end
    object dtsNF_ProdutosINFO_ADICIONAL: TStringField
      FieldName = 'INFO_ADICIONAL'
      ProviderFlags = [pfInUpdate]
      Size = 500
    end
    object dtsNF_ProdutosVLR_TOTAL: TFMTBCDField
      FieldName = 'VLR_TOTAL'
      ProviderFlags = [pfInUpdate]
      Precision = 15
      Size = 2
    end
    object dtsNF_ProdutosVLR_UN_COMERCIAL: TFMTBCDField
      FieldName = 'VLR_UN_COMERCIAL'
      ProviderFlags = [pfInUpdate]
      Required = True
      Precision = 15
      Size = 4
    end
    object dtsNF_ProdutosQTDE_COMERCIAL: TFMTBCDField
      FieldName = 'QTDE_COMERCIAL'
      ProviderFlags = [pfInUpdate]
      Required = True
      Precision = 15
      Size = 4
    end
    object dtsNF_ProdutosUN_COMERCIAL: TStringField
      FieldName = 'UN_COMERCIAL'
      ProviderFlags = [pfInUpdate]
      FixedChar = True
      Size = 6
    end
    object dtsNF_ProdutosCFOP: TStringField
      FieldName = 'CFOP'
      ProviderFlags = [pfInUpdate]
      FixedChar = True
      Size = 4
    end
    object dtsNF_ProdutosGENERO: TStringField
      FieldName = 'GENERO'
      ProviderFlags = [pfInUpdate]
      FixedChar = True
      Size = 18
    end
    object dtsNF_ProdutosEX_TIPI: TStringField
      FieldName = 'EX_TIPI'
      ProviderFlags = [pfInUpdate]
      FixedChar = True
      Size = 3
    end
    object dtsNF_ProdutosVLR_SEGURO: TFMTBCDField
      FieldName = 'VLR_SEGURO'
      ProviderFlags = [pfInUpdate]
      Precision = 15
      Size = 2
    end
    object dtsNF_ProdutosVLR_FRETE: TFMTBCDField
      FieldName = 'VLR_FRETE'
      ProviderFlags = [pfInUpdate]
      Precision = 15
      Size = 2
    end
    object dtsNF_ProdutosVLR_UN_TRIB: TFMTBCDField
      FieldName = 'VLR_UN_TRIB'
      ProviderFlags = [pfInUpdate]
      Precision = 15
      Size = 4
    end
    object dtsNF_ProdutosQTDE_UN_TRIB: TFMTBCDField
      FieldName = 'QTDE_UN_TRIB'
      ProviderFlags = [pfInUpdate]
      Precision = 15
      Size = 4
    end
    object dtsNF_ProdutosUN_TRIB: TStringField
      FieldName = 'UN_TRIB'
      ProviderFlags = [pfInUpdate]
      FixedChar = True
      Size = 6
    end
    object dtsNF_ProdutosEAN_TRIB: TStringField
      FieldName = 'EAN_TRIB'
      ProviderFlags = [pfInUpdate]
      FixedChar = True
      Size = 14
    end
    object dtsNF_ProdutosVLR_DESCONTO: TFMTBCDField
      FieldName = 'VLR_DESCONTO'
      ProviderFlags = [pfInUpdate]
      Precision = 15
      Size = 2
    end
  end
  object dtsNF_Cobranca: TSQLDataSet
    SchemaName = 'sysdba'
    CommandText = 
      'select * from NF_COBRANCA'#13#10'WHERE ID_NOTA_FISCAL = :ID_NOTA_FISCA' +
      'L'
    DbxCommandType = 'Dbx.SQL'
    DataSource = dsNF_Nota
    MaxBlobSize = -1
    Params = <
      item
        DataType = ftInteger
        Name = 'ID_NOTA_FISCAL'
        ParamType = ptInput
      end>
    SQLConnection = dmMain.NfConn
    Left = 152
    Top = 176
    object dtsNF_CobrancaID_NOTA_FISCAL: TIntegerField
      FieldName = 'ID_NOTA_FISCAL'
      ProviderFlags = [pfInUpdate, pfInWhere, pfInKey]
      Required = True
    end
  end
  object dtsNF_Emitente: TSQLDataSet
    SchemaName = 'sysdba'
    CommandText = 
      'select * from NF_EMITENTE'#13#10'WHERE ID_NOTA_FISCAL = :ID_NOTA_FISCA' +
      'L'
    DbxCommandType = 'Dbx.SQL'
    DataSource = dsNF_Nota
    MaxBlobSize = -1
    Params = <
      item
        DataType = ftInteger
        Name = 'ID_NOTA_FISCAL'
        ParamType = ptInput
      end>
    SQLConnection = dmMain.NfConn
    Left = 248
    Top = 176
    object dtsNF_EmitenteID_NOTA_FISCAL: TIntegerField
      FieldName = 'ID_NOTA_FISCAL'
      ProviderFlags = [pfInUpdate, pfInWhere, pfInKey]
      Required = True
    end
    object dtsNF_EmitenteTELEFONE: TStringField
      FieldName = 'TELEFONE'
      ProviderFlags = [pfInUpdate]
      Size = 10
    end
    object dtsNF_EmitenteNM_PAIS: TStringField
      FieldName = 'NM_PAIS'
      ProviderFlags = [pfInUpdate]
      Size = 60
    end
    object dtsNF_EmitenteOD_PAIS: TStringField
      FieldName = 'OD_PAIS'
      ProviderFlags = [pfInUpdate]
      Size = 4
    end
    object dtsNF_EmitenteCEP: TStringField
      FieldName = 'CEP'
      ProviderFlags = [pfInUpdate]
      Size = 8
    end
    object dtsNF_EmitenteUF: TStringField
      FieldName = 'UF'
      ProviderFlags = [pfInUpdate]
      Size = 2
    end
    object dtsNF_EmitenteNM_MUNICIPIO: TStringField
      FieldName = 'NM_MUNICIPIO'
      ProviderFlags = [pfInUpdate]
      Size = 60
    end
    object dtsNF_EmitenteCOD_MUNICIPIO: TStringField
      FieldName = 'COD_MUNICIPIO'
      ProviderFlags = [pfInUpdate]
      Size = 7
    end
    object dtsNF_EmitenteBAIRRO: TStringField
      FieldName = 'BAIRRO'
      ProviderFlags = [pfInUpdate]
      Size = 60
    end
    object dtsNF_EmitenteCOMPLEMENTO: TStringField
      FieldName = 'COMPLEMENTO'
      ProviderFlags = [pfInUpdate]
      Size = 60
    end
    object dtsNF_EmitenteNUMERO: TStringField
      FieldName = 'NUMERO'
      ProviderFlags = [pfInUpdate]
      Size = 60
    end
    object dtsNF_EmitenteLOGRADOURO: TStringField
      FieldName = 'LOGRADOURO'
      ProviderFlags = [pfInUpdate]
      Size = 60
    end
    object dtsNF_EmitenteCNAE: TStringField
      FieldName = 'CNAE'
      ProviderFlags = [pfInUpdate]
      Size = 7
    end
    object dtsNF_EmitenteIM: TStringField
      FieldName = 'IM'
      ProviderFlags = [pfInUpdate]
      Size = 15
    end
    object dtsNF_EmitenteIE_ST: TStringField
      FieldName = 'IE_ST'
      ProviderFlags = [pfInUpdate]
      Size = 14
    end
    object dtsNF_EmitenteIE: TStringField
      FieldName = 'IE'
      ProviderFlags = [pfInUpdate]
      Size = 14
    end
    object dtsNF_EmitenteCNPJ: TStringField
      FieldName = 'CNPJ'
      ProviderFlags = [pfInUpdate]
      FixedChar = True
      Size = 14
    end
    object dtsNF_EmitenteNM_FANTASIA: TStringField
      FieldName = 'NM_FANTASIA'
      ProviderFlags = [pfInUpdate]
      Size = 60
    end
    object dtsNF_EmitenteRAZAO_SOCIAL: TStringField
      FieldName = 'RAZAO_SOCIAL'
      ProviderFlags = [pfInUpdate]
      Size = 60
    end
  end
  object dtsNF_Exportacao: TSQLDataSet
    SchemaName = 'sysdba'
    CommandText = 
      'select * from NF_EXPORTACAO'#13#10'WHERE ID_NOTA_FISCAL = :ID_NOTA_FIS' +
      'CAL'
    DbxCommandType = 'Dbx.SQL'
    DataSource = dsNF_Nota
    MaxBlobSize = -1
    Params = <
      item
        DataType = ftInteger
        Name = 'ID_NOTA_FISCAL'
        ParamType = ptInput
      end>
    SQLConnection = dmMain.NfConn
    Left = 344
    Top = 176
    object dtsNF_ExportacaoID_NOTA_FISCAL: TIntegerField
      FieldName = 'ID_NOTA_FISCAL'
      ProviderFlags = [pfInUpdate, pfInWhere, pfInKey]
      Required = True
    end
  end
  object dtsNF_Inf_Adicional: TSQLDataSet
    SchemaName = 'sysdba'
    CommandText = 
      'select *  from NF_INFORMACAO_ADICIONAL'#13#10'WHERE ID_NOTA_FISCAL = :' +
      'ID_NOTA_FISCAL'
    DbxCommandType = 'Dbx.SQL'
    DataSource = dsNF_Nota
    MaxBlobSize = -1
    Params = <
      item
        DataType = ftInteger
        Name = 'ID_NOTA_FISCAL'
        ParamType = ptInput
      end>
    SQLConnection = dmMain.NfConn
    Left = 448
    Top = 176
    object dtsNF_Inf_AdicionalID_NOTA_FISCAL: TIntegerField
      FieldName = 'ID_NOTA_FISCAL'
      ProviderFlags = [pfInUpdate, pfInWhere, pfInKey]
      Required = True
    end
  end
  object dtsNF_Local_Retirada: TSQLDataSet
    SchemaName = 'sysdba'
    CommandText = 
      'select *  from NF_LOCAL_RETIRADA'#13#10'WHERE ID_NOTA_FISCAL = :ID_NOT' +
      'A_FISCAL'
    DbxCommandType = 'Dbx.SQL'
    DataSource = dsNF_Nota
    MaxBlobSize = -1
    Params = <
      item
        DataType = ftInteger
        Name = 'ID_NOTA_FISCAL'
        ParamType = ptInput
      end>
    SQLConnection = dmMain.NfConn
    Left = 176
    Top = 248
    object dtsNF_Local_RetiradaID_NOTA_FISCAL: TIntegerField
      FieldName = 'ID_NOTA_FISCAL'
      ProviderFlags = [pfInUpdate, pfInWhere, pfInKey]
      Required = True
    end
    object dtsNF_Local_RetiradaCNPJ: TStringField
      FieldName = 'CNPJ'
      ProviderFlags = [pfInUpdate]
      FixedChar = True
      Size = 14
    end
    object dtsNF_Local_RetiradaUF: TStringField
      FieldName = 'UF'
      ProviderFlags = [pfInUpdate]
      FixedChar = True
      Size = 2
    end
    object dtsNF_Local_RetiradaNM_MUNICIPIO: TStringField
      FieldName = 'NM_MUNICIPIO'
      ProviderFlags = [pfInUpdate]
      Size = 60
    end
    object dtsNF_Local_RetiradaCOD_MUNICIPIO: TStringField
      FieldName = 'COD_MUNICIPIO'
      ProviderFlags = [pfInUpdate]
      FixedChar = True
      Size = 7
    end
    object dtsNF_Local_RetiradaBAIRRO: TStringField
      FieldName = 'BAIRRO'
      ProviderFlags = [pfInUpdate]
      Size = 60
    end
    object dtsNF_Local_RetiradaCOMPLEMENTO: TStringField
      FieldName = 'COMPLEMENTO'
      ProviderFlags = [pfInUpdate]
      Size = 60
    end
    object dtsNF_Local_RetiradaNUMERO: TStringField
      FieldName = 'NUMERO'
      ProviderFlags = [pfInUpdate]
      Size = 60
    end
    object dtsNF_Local_RetiradaLOGRADOURO: TStringField
      FieldName = 'LOGRADOURO'
      ProviderFlags = [pfInUpdate]
      Size = 60
    end
  end
  object dts_NF_Referenciada: TSQLDataSet
    SchemaName = 'sysdba'
    CommandText = 
      'select *  from NF_REFERENCIADA'#13#10'WHERE ID_NOTA_FISCAL = :ID_NOTA_' +
      'FISCAL'
    DbxCommandType = 'Dbx.SQL'
    DataSource = dsNF_Nota
    MaxBlobSize = -1
    Params = <
      item
        DataType = ftInteger
        Name = 'ID_NOTA_FISCAL'
        ParamType = ptInput
      end>
    SQLConnection = dmMain.NfConn
    Left = 464
    Top = 248
    object dts_NF_ReferenciadaID_NOTA_FISCAL: TIntegerField
      FieldName = 'ID_NOTA_FISCAL'
      ProviderFlags = [pfInUpdate, pfInWhere, pfInKey]
      Required = True
    end
    object dts_NF_ReferenciadaNUMERO: TStringField
      FieldName = 'NUMERO'
      ProviderFlags = [pfInUpdate]
      FixedChar = True
      Size = 9
    end
    object dts_NF_ReferenciadaSERIE: TStringField
      FieldName = 'SERIE'
      ProviderFlags = [pfInUpdate]
      FixedChar = True
      Size = 3
    end
    object dts_NF_ReferenciadaMODELO: TStringField
      FieldName = 'MODELO'
      ProviderFlags = [pfInUpdate]
      FixedChar = True
      Size = 2
    end
    object dts_NF_ReferenciadaCHAVE_NF_REF: TStringField
      FieldName = 'CHAVE_NF_REF'
      ProviderFlags = [pfInUpdate]
      FixedChar = True
      Size = 44
    end
    object dts_NF_ReferenciadaCNPJ: TStringField
      FieldName = 'CNPJ'
      ProviderFlags = [pfInUpdate]
      FixedChar = True
      Size = 14
    end
    object dts_NF_ReferenciadaANO_MES: TStringField
      FieldName = 'ANO_MES'
      ProviderFlags = [pfInUpdate]
      FixedChar = True
      Size = 6
    end
    object dts_NF_ReferenciadaUF: TStringField
      FieldName = 'UF'
      ProviderFlags = [pfInUpdate]
      FixedChar = True
      Size = 2
    end
  end
  object dtsNF_Situacao: TSQLDataSet
    SchemaName = 'sysdba'
    CommandText = 'select *  from NF_STATUS'#13#10'WHERE ID_NOTA_FISCAL = :ID_NOTA_FISCAL'
    DbxCommandType = 'Dbx.SQL'
    DataSource = dsNF_Nota
    MaxBlobSize = -1
    Params = <
      item
        DataType = ftInteger
        Name = 'ID_NOTA_FISCAL'
        ParamType = ptInput
      end>
    SQLConnection = dmMain.NfConn
    Left = 64
    Top = 328
    object dtsNF_SituacaoID_NOTA_FISCAL: TIntegerField
      FieldName = 'ID_NOTA_FISCAL'
      ProviderFlags = [pfInUpdate, pfInWhere, pfInKey]
      Required = True
    end
    object dtsNF_SituacaoCOD_SITUACAO: TIntegerField
      FieldName = 'COD_SITUACAO'
      ProviderFlags = [pfInUpdate, pfInWhere, pfInKey]
    end
    object dtsNF_SituacaoDT_SITUACAO: TSQLTimeStampField
      FieldName = 'DT_SITUACAO'
      ProviderFlags = [pfInUpdate]
      Required = True
    end
  end
  object dtsNF_Totais: TSQLDataSet
    SchemaName = 'sysdba'
    CommandText = 'select *  from NF_TOTAIS'#13#10'WHERE ID_NOTA_FISCAL = :ID_NOTA_FISCAL'
    DbxCommandType = 'Dbx.SQL'
    DataSource = dsNF_Nota
    MaxBlobSize = -1
    Params = <
      item
        DataType = ftInteger
        Name = 'ID_NOTA_FISCAL'
        ParamType = ptInput
      end>
    SQLConnection = dmMain.NfConn
    Left = 144
    Top = 328
    object dtsNF_TotaisID_NOTA_FISCAL: TIntegerField
      FieldName = 'ID_NOTA_FISCAL'
      ProviderFlags = [pfInUpdate, pfInWhere, pfInKey]
      Required = True
    end
  end
  object dtsNF_Trasporte: TSQLDataSet
    SchemaName = 'sysdba'
    CommandText = 
      'select *  from NF_TRANSPORTE'#13#10'WHERE ID_NOTA_FISCAL = :ID_NOTA_FI' +
      'SCAL'
    DbxCommandType = 'Dbx.SQL'
    DataSource = dsNF_Nota
    MaxBlobSize = -1
    Params = <
      item
        DataType = ftInteger
        Name = 'ID_NOTA_FISCAL'
        ParamType = ptInput
      end>
    SQLConnection = dmMain.NfConn
    Left = 232
    Top = 328
    object dtsNF_TrasporteID_NOTA_FISCAL: TIntegerField
      FieldName = 'ID_NOTA_FISCAL'
      ProviderFlags = [pfInUpdate, pfInWhere, pfInKey]
      Required = True
    end
    object dtsNF_TrasporteNM_MUNICIPIO: TStringField
      FieldName = 'NM_MUNICIPIO'
      ProviderFlags = [pfInUpdate]
      Size = 60
    end
    object dtsNF_TrasporteUF: TStringField
      FieldName = 'UF'
      ProviderFlags = [pfInUpdate]
      FixedChar = True
      Size = 2
    end
    object dtsNF_TrasporteENDERECO: TStringField
      FieldName = 'ENDERECO'
      ProviderFlags = [pfInUpdate]
      Size = 60
    end
    object dtsNF_TrasporteIE: TStringField
      FieldName = 'IE'
      ProviderFlags = [pfInUpdate]
      FixedChar = True
      Size = 14
    end
    object dtsNF_TrasporteNOME: TStringField
      FieldName = 'NOME'
      ProviderFlags = [pfInUpdate]
      FixedChar = True
      Size = 60
    end
    object dtsNF_TrasporteCNPJ_TRANS: TStringField
      FieldName = 'CNPJ_TRANS'
      ProviderFlags = [pfInUpdate]
      FixedChar = True
      Size = 14
    end
    object dtsNF_TrasporteMOD_FRETE: TSmallintField
      FieldName = 'MOD_FRETE'
      ProviderFlags = [pfInUpdate]
    end
  end
  object dsNF_Nota: TDataSource
    DataSet = dtsNF_Nota
    Left = 288
    Top = 280
  end
  object dtsNF_Local_Entrega: TSQLDataSet
    SchemaName = 'sysdba'
    CommandText = 
      'select *  from NF_LOCAL_ENTREGA'#13#10'WHERE ID_NOTA_FISCAL = :ID_NOTA' +
      '_FISCAL'
    DbxCommandType = 'Dbx.SQL'
    DataSource = dsNF_Nota
    MaxBlobSize = -1
    Params = <
      item
        DataType = ftInteger
        Name = 'ID_NOTA_FISCAL'
        ParamType = ptInput
      end>
    SQLConnection = dmMain.NfConn
    Left = 56
    Top = 248
    object dtsNF_Local_EntregaID_NOTA_FISCAL: TIntegerField
      FieldName = 'ID_NOTA_FISCAL'
      ProviderFlags = [pfInUpdate, pfInWhere, pfInKey]
      Required = True
    end
    object dtsNF_Local_EntregaCNPJ: TStringField
      FieldName = 'CNPJ'
      ProviderFlags = [pfInUpdate]
      FixedChar = True
      Size = 14
    end
    object dtsNF_Local_EntregaUF: TStringField
      FieldName = 'UF'
      ProviderFlags = [pfInUpdate]
      FixedChar = True
      Size = 2
    end
    object dtsNF_Local_EntregaNM_MUNICIPIO: TStringField
      FieldName = 'NM_MUNICIPIO'
      ProviderFlags = [pfInUpdate]
      Size = 60
    end
    object dtsNF_Local_EntregaCOD_MUNICIPIO: TStringField
      FieldName = 'COD_MUNICIPIO'
      ProviderFlags = [pfInUpdate]
      Size = 7
    end
    object dtsNF_Local_EntregaBAIRRO: TStringField
      FieldName = 'BAIRRO'
      ProviderFlags = [pfInUpdate]
      Size = 60
    end
    object dtsNF_Local_EntregaCOMPLEMENTO: TStringField
      FieldName = 'COMPLEMENTO'
      ProviderFlags = [pfInUpdate]
      Size = 60
    end
    object dtsNF_Local_EntregaNUMERO: TStringField
      FieldName = 'NUMERO'
      ProviderFlags = [pfInUpdate]
      Size = 60
    end
    object dtsNF_Local_EntregaLOGRADOURO: TStringField
      FieldName = 'LOGRADOURO'
      ProviderFlags = [pfInUpdate]
      Size = 60
    end
  end
  object dtsNF_CLIENTE: TSQLDataSet
    SchemaName = 'sysdba'
    CommandText = 'select * from NF_CLIENTE'#13#10'WHERE ID_NOTA_FISCAL = :ID_NOTA_FISCAL'
    DbxCommandType = 'Dbx.SQL'
    DataSource = dsNF_Nota
    MaxBlobSize = -1
    Params = <
      item
        DataType = ftInteger
        Name = 'ID_NOTA_FISCAL'
        ParamType = ptInput
      end>
    SQLConnection = dmMain.NfConn
    Left = 56
    Top = 176
    object dtsNF_CLIENTEID_NOTA_FISCAL: TIntegerField
      FieldName = 'ID_NOTA_FISCAL'
      ProviderFlags = [pfInUpdate, pfInWhere, pfInKey]
      Required = True
    end
    object dtsNF_CLIENTECPF_CNPJ: TStringField
      FieldName = 'CPF_CNPJ'
      ProviderFlags = [pfInUpdate]
      FixedChar = True
      Size = 14
    end
    object dtsNF_CLIENTETIPO_PESSOA: TSmallintField
      FieldName = 'TIPO_PESSOA'
      ProviderFlags = [pfInUpdate]
      Required = True
    end
    object dtsNF_CLIENTENOME: TStringField
      FieldName = 'NOME'
      ProviderFlags = [pfInUpdate]
      FixedChar = True
      Size = 60
    end
    object dtsNF_CLIENTEIE: TStringField
      FieldName = 'IE'
      ProviderFlags = [pfInUpdate]
      FixedChar = True
      Size = 14
    end
    object dtsNF_CLIENTELOGRADOURO: TStringField
      FieldName = 'LOGRADOURO'
      ProviderFlags = [pfInUpdate]
      Size = 60
    end
    object dtsNF_CLIENTEINSC_SUFRAMA: TStringField
      FieldName = 'INSC_SUFRAMA'
      ProviderFlags = [pfInUpdate]
      FixedChar = True
      Size = 9
    end
    object dtsNF_CLIENTECOMPLEMENTO: TStringField
      FieldName = 'COMPLEMENTO'
      ProviderFlags = [pfInUpdate]
      Size = 60
    end
    object dtsNF_CLIENTEBAIRRO: TStringField
      FieldName = 'BAIRRO'
      ProviderFlags = [pfInUpdate]
      Size = 60
    end
    object dtsNF_CLIENTENUMERO: TStringField
      FieldName = 'NUMERO'
      ProviderFlags = [pfInUpdate]
      Size = 60
    end
    object dtsNF_CLIENTETELEFONE: TStringField
      FieldName = 'TELEFONE'
      ProviderFlags = [pfInUpdate]
      FixedChar = True
      Size = 10
    end
    object dtsNF_CLIENTENM_PAIS: TStringField
      FieldName = 'NM_PAIS'
      ProviderFlags = [pfInUpdate]
      Size = 60
    end
    object dtsNF_CLIENTECOD_PAIS: TStringField
      FieldName = 'COD_PAIS'
      ProviderFlags = [pfInUpdate]
      FixedChar = True
      Size = 4
    end
    object dtsNF_CLIENTECEP: TStringField
      FieldName = 'CEP'
      ProviderFlags = [pfInUpdate]
      FixedChar = True
      Size = 8
    end
    object dtsNF_CLIENTEUF: TStringField
      FieldName = 'UF'
      ProviderFlags = [pfInUpdate]
      FixedChar = True
      Size = 2
    end
    object dtsNF_CLIENTENM_MUNICIPIO: TStringField
      FieldName = 'NM_MUNICIPIO'
      ProviderFlags = [pfInUpdate]
      FixedChar = True
      Size = 60
    end
    object dtsNF_CLIENTECOD_MUNICIPIO: TStringField
      FieldName = 'COD_MUNICIPIO'
      ProviderFlags = [pfInUpdate]
      FixedChar = True
      Size = 7
    end
  end
  object dspCad_Cliente: TDataSetProvider
    DataSet = dtsCad_Clientes
    UpdateMode = upWhereKeyOnly
    Left = 56
    Top = 32
  end
  object dtsCad_Clientes: TSQLDataSet
    SchemaName = 'sysdba'
    CommandText = 'select *  from CAD_CLIENTES'#13#10'WHERE ID_CLIENTE  = :ID_CLIENTE'
    DbxCommandType = 'Dbx.SQL'
    MaxBlobSize = -1
    Params = <
      item
        DataType = ftInteger
        Name = 'ID_CLIENTE'
        ParamType = ptInput
      end>
    SQLConnection = dmMain.NfConn
    Left = 40
    Top = 16
    object dtsCad_ClientesID_CLIENTE: TIntegerField
      FieldName = 'ID_CLIENTE'
      ProviderFlags = [pfInUpdate, pfInWhere, pfInKey]
      Required = True
    end
    object dtsCad_ClientesCPF_CNPJ: TStringField
      FieldName = 'CPF_CNPJ'
      ProviderFlags = [pfInUpdate]
      Required = True
      FixedChar = True
      Size = 14
    end
    object dtsCad_ClientesNOME: TStringField
      FieldName = 'NOME'
      ProviderFlags = [pfInUpdate]
      Required = True
      FixedChar = True
      Size = 60
    end
    object dtsCad_ClientesNOME_FANTASIA: TStringField
      FieldName = 'NOME_FANTASIA'
      ProviderFlags = [pfInUpdate]
      FixedChar = True
      Size = 60
    end
    object dtsCad_ClientesINSC_SUFRAMA: TStringField
      FieldName = 'INSC_SUFRAMA'
      ProviderFlags = [pfInUpdate]
      FixedChar = True
      Size = 9
    end
    object dtsCad_ClientesIE: TStringField
      FieldName = 'IE'
      ProviderFlags = [pfInUpdate]
      FixedChar = True
      Size = 14
    end
    object dtsCad_ClientesTP_PESSOA: TStringField
      FieldName = 'TP_PESSOA'
      ProviderFlags = [pfInUpdate]
      FixedChar = True
      Size = 1
    end
    object dtsCad_ClientesTELEFONE: TStringField
      FieldName = 'TELEFONE'
      ProviderFlags = [pfInUpdate]
      FixedChar = True
      Size = 10
    end
    object dtsCad_ClientesPAIS: TStringField
      FieldName = 'PAIS'
      ProviderFlags = [pfInUpdate]
      FixedChar = True
      Size = 60
    end
    object dtsCad_ClientesCOD_PAIS: TStringField
      FieldName = 'COD_PAIS'
      ProviderFlags = [pfInUpdate]
      FixedChar = True
      Size = 4
    end
    object dtsCad_ClientesCEP: TStringField
      FieldName = 'CEP'
      ProviderFlags = [pfInUpdate]
      FixedChar = True
      Size = 8
    end
    object dtsCad_ClientesUF: TStringField
      FieldName = 'UF'
      ProviderFlags = [pfInUpdate]
      FixedChar = True
      Size = 2
    end
    object dtsCad_ClientesMUNICIPIO: TStringField
      FieldName = 'MUNICIPIO'
      ProviderFlags = [pfInUpdate]
      FixedChar = True
      Size = 60
    end
    object dtsCad_ClientesCOD_MUNICIPIO: TStringField
      FieldName = 'COD_MUNICIPIO'
      ProviderFlags = [pfInUpdate]
      FixedChar = True
      Size = 7
    end
    object dtsCad_ClientesBAIRRO: TStringField
      FieldName = 'BAIRRO'
      ProviderFlags = [pfInUpdate]
      FixedChar = True
      Size = 60
    end
    object dtsCad_ClientesCOMPLEMENTO: TStringField
      FieldName = 'COMPLEMENTO'
      ProviderFlags = [pfInUpdate]
      FixedChar = True
      Size = 60
    end
    object dtsCad_ClientesNUMERO: TStringField
      FieldName = 'NUMERO'
      ProviderFlags = [pfInUpdate]
      FixedChar = True
      Size = 60
    end
    object dtsCad_ClientesLOGRADOURO: TStringField
      FieldName = 'LOGRADOURO'
      ProviderFlags = [pfInUpdate]
      FixedChar = True
      Size = 60
    end
  end
  object dspCad_Emitente: TDataSetProvider
    DataSet = dtsCad_Emitente
    UpdateMode = upWhereKeyOnly
    Left = 152
    Top = 32
  end
  object dtsCad_Emitente: TSQLDataSet
    SchemaName = 'sysdba'
    CommandText = 'select *  from  CAD_EMITENTES'#13#10'WHERE ID_EMITENTE  = :ID_EMITENTE'
    DbxCommandType = 'Dbx.SQL'
    MaxBlobSize = -1
    Params = <
      item
        DataType = ftInteger
        Name = 'ID_EMITENTE'
        ParamType = ptInput
      end>
    SQLConnection = dmMain.NfConn
    Left = 136
    Top = 16
    object dtsCad_EmitenteID_EMITENTE: TIntegerField
      FieldName = 'ID_EMITENTE'
      ProviderFlags = [pfInUpdate, pfInWhere, pfInKey]
      Required = True
    end
    object dtsCad_EmitenteCNAE: TStringField
      FieldName = 'CNAE'
      ProviderFlags = [pfInUpdate]
      FixedChar = True
      Size = 7
    end
    object dtsCad_EmitenteINSC_MUNICIPAL: TStringField
      FieldName = 'INSC_MUNICIPAL'
      ProviderFlags = [pfInUpdate]
      FixedChar = True
      Size = 15
    end
    object dtsCad_EmitenteIE_ST: TStringField
      FieldName = 'IE_ST'
      ProviderFlags = [pfInUpdate]
      FixedChar = True
      Size = 14
    end
    object dtsCad_EmitenteINSC_ESTADUAL: TStringField
      FieldName = 'INSC_ESTADUAL'
      ProviderFlags = [pfInUpdate]
      FixedChar = True
      Size = 14
    end
    object dtsCad_EmitenteNOME_FANTASIA: TStringField
      FieldName = 'NOME_FANTASIA'
      ProviderFlags = [pfInUpdate]
      FixedChar = True
      Size = 60
    end
    object dtsCad_EmitenteRAZAO_SOCIAL: TStringField
      FieldName = 'RAZAO_SOCIAL'
      ProviderFlags = [pfInUpdate]
      Required = True
      FixedChar = True
      Size = 60
    end
    object dtsCad_EmitenteCNPJ: TStringField
      FieldName = 'CNPJ'
      ProviderFlags = [pfInUpdate]
      Required = True
      FixedChar = True
      Size = 14
    end
    object dtsCad_EmitenteBAIRRO: TStringField
      FieldName = 'BAIRRO'
      ProviderFlags = [pfInUpdate]
      FixedChar = True
      Size = 60
    end
    object dtsCad_EmitenteCOMPLEMENTO: TStringField
      FieldName = 'COMPLEMENTO'
      ProviderFlags = [pfInUpdate]
      FixedChar = True
      Size = 60
    end
    object dtsCad_EmitenteNUMERO: TStringField
      FieldName = 'NUMERO'
      ProviderFlags = [pfInUpdate]
      FixedChar = True
      Size = 60
    end
    object dtsCad_EmitenteLOGRADOURO: TStringField
      FieldName = 'LOGRADOURO'
      ProviderFlags = [pfInUpdate]
      FixedChar = True
      Size = 60
    end
    object dtsCad_EmitenteUF: TStringField
      FieldName = 'UF'
      ProviderFlags = [pfInUpdate]
      FixedChar = True
      Size = 2
    end
    object dtsCad_EmitenteMUNICIPIO: TStringField
      FieldName = 'MUNICIPIO'
      ProviderFlags = [pfInUpdate]
      FixedChar = True
      Size = 60
    end
    object dtsCad_EmitenteCOD_MUNICIPIO: TStringField
      FieldName = 'COD_MUNICIPIO'
      ProviderFlags = [pfInUpdate]
      FixedChar = True
      Size = 7
    end
    object dtsCad_EmitenteCOD_PAIS: TStringField
      FieldName = 'COD_PAIS'
      ProviderFlags = [pfInUpdate]
      FixedChar = True
      Size = 4
    end
    object dtsCad_EmitenteCEP: TStringField
      FieldName = 'CEP'
      ProviderFlags = [pfInUpdate]
      FixedChar = True
      Size = 8
    end
    object dtsCad_EmitentePAIS: TStringField
      FieldName = 'PAIS'
      ProviderFlags = [pfInUpdate]
      FixedChar = True
      Size = 60
    end
    object dtsCad_EmitenteTELEFONE: TStringField
      FieldName = 'TELEFONE'
      ProviderFlags = [pfInUpdate]
      FixedChar = True
      Size = 10
    end
  end
  object dspCad_Transportadora: TDataSetProvider
    DataSet = dtsCad_Transportadora
    UpdateMode = upWhereKeyOnly
    Left = 272
    Top = 32
  end
  object dtsCad_Transportadora: TSQLDataSet
    SchemaName = 'sysdba'
    CommandText = 
      'select *  from   CAD_TRANSPORTADORAS'#13#10'WHERE ID_TRANSPORTADORA = ' +
      ':ID_TRANSPORTADORA'
    DbxCommandType = 'Dbx.SQL'
    MaxBlobSize = -1
    Params = <
      item
        DataType = ftInteger
        Name = 'ID_TRANSPORTADORA'
        ParamType = ptInput
      end>
    SQLConnection = dmMain.NfConn
    Left = 256
    Top = 16
    object dtsCad_TransportadoraID_TRANSPORTADORA: TIntegerField
      FieldName = 'ID_TRANSPORTADORA'
      ProviderFlags = [pfInUpdate, pfInWhere, pfInKey]
      Required = True
    end
    object dtsCad_TransportadoraCPF_CNPJ: TStringField
      FieldName = 'CPF_CNPJ'
      ProviderFlags = [pfInUpdate]
      FixedChar = True
      Size = 14
    end
    object dtsCad_TransportadoraNOME: TStringField
      FieldName = 'NOME'
      ProviderFlags = [pfInUpdate]
      Required = True
      FixedChar = True
      Size = 60
    end
    object dtsCad_TransportadoraMUNICIPIO: TStringField
      FieldName = 'MUNICIPIO'
      ProviderFlags = [pfInUpdate]
      FixedChar = True
      Size = 60
    end
    object dtsCad_TransportadoraUF: TStringField
      FieldName = 'UF'
      ProviderFlags = [pfInUpdate]
      FixedChar = True
      Size = 2
    end
    object dtsCad_TransportadoraENDERECO: TStringField
      FieldName = 'ENDERECO'
      ProviderFlags = [pfInUpdate]
      Size = 60
    end
    object dtsCad_TransportadoraIE: TStringField
      FieldName = 'IE'
      ProviderFlags = [pfInUpdate]
      FixedChar = True
      Size = 14
    end
  end
end
